home *** CD-ROM | disk | FTP | other *** search
/ Winzipper / Winzipper_ISO.iso / programming / oracle7 7.2 / DB / UTIL72 / CATNOPRC.SQL < prev    next >
Encoding:
Text File  |  1995-05-09  |  1.9 KB  |  87 lines
  1. rem 
  2. rem $Header: catnoprc.sql 7020100.1 94/09/23 22:14:26 cli Generic<base> $ noprctrg.sql 
  3. rem 
  4. Rem Copyright (c) 1990 by Oracle Corporation
  5. Rem NAME
  6. REM    CATNOPRC.SQL
  7. Rem  FUNCTION
  8. Rem    Drop the stored procedure and trigger catalog views, created by
  9. Rem    prctrg.sql.
  10. Rem  NOTES
  11. Rem    Must be run while connected to SYS.
  12. Rem    Be sure to keep this file synchronized with catalog.sql and prctrg.sql
  13. Rem  MODIFIED
  14. Rem     glumpkin   10/20/92 -  Renamed from NOPRCTRG.SQL 
  15. Rem     rkooi      01/18/92 -  add synonym 
  16. Rem     rkooi      01/18/92 -  add object_size views 
  17. Rem     rkooi      10/20/91 -  add public_dependency 
  18. Rem     rkooi      05/22/91 -         get rid of _object in some catalog names 
  19. Rem     rkooi      05/22/91 - change *_references to *_dependencies cat
  20. Rem     rkooi      05/05/91 - add ALL_TRIGGERS 
  21. Rem     rkooi      04/01/91 - add new catalogs for diana, pcode, etc. 
  22. Rem     rkooi      03/12/91 - Creation
  23. Rem
  24.  
  25. drop view USER_ERRORS
  26. /
  27. drop public synonym USER_ERRORS
  28. /
  29. drop view ALL_ERRORS
  30. /
  31. drop public synonym ALL_ERRORS
  32. /
  33. drop view DBA_ERRORS
  34. /
  35. drop view USER_SOURCE
  36. /
  37. drop public synonym USER_SOURCE
  38. /
  39. drop view ALL_SOURCE
  40. /
  41. drop public synonym ALL_SOURCE
  42. /
  43. drop view DBA_SOURCE
  44. /
  45. drop view USER_TRIGGERS
  46. /
  47. drop public synonym USER_TRIGGERS
  48. /
  49. drop view ALL_TRIGGERS
  50. /
  51. drop public synonym ALL_TRIGGERS
  52. /
  53. drop view DBA_TRIGGERS
  54. /
  55. drop view USER_DEPENDENCIES
  56. /
  57. drop public synonym USER_DEPENDENCIES
  58. /
  59. drop view ALL_DEPENDENCIES
  60. /
  61. drop public synonym ALL_DEPENDENCIES
  62. /
  63. drop view DBA_DEPENDENCIES
  64. /
  65. drop view PUBLIC_DEPENDENCY
  66. /
  67. drop public synonym PUBLIC_DEPENDENCY
  68. /
  69. drop view CODE_PIECES
  70. /
  71. drop view CODE_SIZE
  72. /
  73. drop view PARSED_PIECES
  74. /
  75. drop view PARSED_SIZE
  76. /
  77. drop view SOURCE_SIZE
  78. /
  79. drop view ERROR_SIZE
  80. /
  81. drop view DBA_OBJECT_SIZE
  82. /
  83. drop view USER_OBJECT_SIZE
  84. /
  85. drop public synonym USER_OBJECT_SIZE
  86. /
  87.